Question: you need to divide the number of cars by the number of people to calculate cars per person on day one. Which formula can you type in Cell D92 to do this? you need to divide the number of cars by the number of people to calculate cars per person on day one. Which formula can you type in Cell D92 to do this?

Question

Anu Bhardwaj · Accepted Answer

To calculate cars per person on day one in Excel, where:

The number of cars is in one cell (e.g., B92)
The number of people is in another cell (e.g., C92)

You would type the following formula in Cell D92:

=B92/C92

🔍 Explanation:

B92 = number of cars
C92 = number of people
D92 will show cars per person by dividing the value in B92 by the value in C92.

⚠️ Tip: To avoid division errors (like dividing by zero), you could use:

=IF(C92=0, "N/A", B92/C92)

Civil engineering

Civil engineering

Question: you need to divide the number of cars by the number of people to calculate cars per person on day one. Which formula can you type in Cell D92 to do this?

Anu Bhardwaj

Answer

Extracted Transcript from Images